True if the specified cell is part of an array formula. Read-only Variant.
expression.HasArray
expression Required. An expression that returns a Range object.
Use the CurrentArray property to determine the the cells that are part of the current array.
This example determines whether the active cell in Spreadsheet1 is part of an array. Is so, the array is selected.
If Spreadsheet1.ActiveCell.HasArray Then _
Spreadsheet1.ActiveCell.CurrentArray.Select